-
Re: INDEX and MATCH across two sheets: a detailed explanation
Example: A Tale of Two Sheets For this example, we'll have 2 sheets that have the same info on each, minus one column on the "Public" sheet. The first sheet we will call "Companies_Pri…6 · -
Re: Alert Someone > Send to Microsoft Teams | How to not include other rows
Select only your "Primary" column (could be named "Item Name", etc. - whatever you generally use). Add your custom message. That ought to do it, right? Here's an example within Te…1 · -
Re: A formula to count a series of "Health Status" in a column to display the status with the largest #?
Couple options for this, but here's a straightforward answer. Go to your Sheet Summary. Add 4 new fields, add these formulas in them: Green Total =COUNTIFS([Overall Health]:[Overall Health], "Gr…1 · -
Re: Scoring Formulas
Actually, @Amelia C. Thibault, I figured out why it's not working in the "SUM" formula Parker recommended above. Your formula has quotes around the numerical values, and Smartsheet is readi…1 · -
Re: Google Sheet Embedded in Dashboard Not Editable
Hey Leah, Embedding items like Google Sheets, Docs, Microsoft Word Docs, PowerPoint, etc. - they're all read-only. Basically, consider them to be a "window" to the actual item - but they ar…1 ·